The Planned Sales Demand is used when LS Replenishment calculates the Replenishment Item Quantities for an Item and the Replenishment Calculation Type is set to Average Usageor Manual Estimate.
Planned Sales Demand lets the buyer set up a planned future sales demand for an item in a store for a specific Date. This Planned Sales Demand will be used instead of the calculated forecast based on the Average Daily Sales or Manual Estimate.
This can be used for special events, as these events may not be seasonal and the Replenishment Forward Sales Profile takes them into effect.
If the Store Stock Cover (Days) field is filled in for an item and the Replenishment Calculation Type is Average Usage or Manual Estimate, the system tries to find Planned Sales Demand records for a period starting today and ending by the number of days defined in the Store Stock Cover (Days) field.
This means, for example, that if the Store Stock Cover (Days) is 5, the period the system looks for Planned Sales Demand records starts today and ends 5 days later. If the system finds Planned Demand records during this period for the item and the store, it uses this information to update the Average Daily Sales.
Replenishment Planned Sales Demand is used for the calculation of the Average Daily Sales quantity when the data in the Replenishment Item Quantity table is calculated.
Example:
Today is 15.08.07
Item 40000 has the Store Stock Cover Days of 10.
The Manual Estimated Daily Sale is 5 per day.
Item 40000 has 10 Replenishment Planned Sales Demand records with the quantity of 20 per day.
The result of the replenishment system calculations:
| Result without Planned Sales Demand | Result with Planned Sales Demand | |
|---|---|---|
| 16.08.07 | 5 | 20 |
| 17.08.07 | 5 | 20 |
| 18.08.07 | 5 | 20 |
| 19.08.07 | 5 | 20 |
| 20.08.07 | 5 | 5 |
| 21.08.07 | 5 | 5 |
| 22.08.07 | 5 | 5 |
| 23.08.07 | 5 | 5 |
| 24.08.07 | 5 | 5 |
| 25.08.07 | 5 | 5 |
|
Total |
50 | 110 |
| Average | 5 | 11 |
The Planned Sales Demand has changed the Average Sale per day from 5 to 11 per day and therefore the system suggested sale will be 11 instead of 50.
This image shows how the data is presented in the system.
See Also